Modify AWR collection intervals and manually create or delete AWR collections

-- the default AWR is executed every hour, and SQL > select * from dba_hist_wr_control;DBID SNAP_INTERVAL RETENTION TOPNSQL C is retained for 8 days.

2022-06-01 Database 我要分享

Innobackupex remote backup

Applies to DC1-> DC2 or mysql replicationDC2. Receiver: listening interface 1234nc-l 1234 | tar ixvf-2 > xtrabackup.logroot@pytho

2022-06-01 Database 我要分享

In-depth analysis of the ext2 file system

For a long time, I wanted to write an article about the ext family file system. When I was at work, I accidentally deleted a lot of files by rm-rf. I really wanted to have a data recovery software that could help me recover the data. Of course, to learn about data recovery, you must first learn about the file system. Most

2022-06-02 Servers 我要分享

What is the local RPM installation method for PostgreSQL 10.12?

This article mainly introduces "what is the method of local RPM installation in PostgreSQL 10.12". In the daily operation, I believe that many people have doubts about the method of local RPM installation in PostgreSQL 10.12. The editor consulted all kinds of materials.

2022-05-31 Database 我要分享

How to check Linux server performance

This article mainly introduces how to check the performance of the Linux server, the article is very detailed, has a certain reference value, interested friends must read it! Overview you can get a general idea of system resource usage within 1 minute by executing the following command. Uptime d

2022-06-01 Servers 我要分享

Example Analysis of performance diagnosis of Linux within 60000 milliseconds

This article introduces you the example analysis of Linux performance diagnosis within 60000 milliseconds, the content is very detailed, interested friends can refer to, hope to be helpful to you. When you find a system performance problem on the Linux server, at the beginning of 1

2022-06-01 Servers 我要分享

How to analyze the performance of Linux

Today, I will talk to you about how to analyze the performance of Linux. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. When you log in to a Linux server, because of a question

2022-06-01 Servers 我要分享

Using orderly and efficient implementation of intersection and Union difference set Operation

It seems that the simple set operation is placed in big data's scene, if you still want to achieve high performance, you need to fully understand the data features and computational features in order to design an efficient algorithm. Making full use of sequential operation is a good way! Intersection and union difference is a common set operation, the corresponding intersec in SQL.

2022-06-03 Internet Technology 我要分享

MySQL optimized federated index

1. Table structure (root@localhost) [test] > show create table t_demo\ Gbomber * 1. Row *

2022-06-01 Database 我要分享

The method of querying the usage information of a disk within a specified time

This article mainly introduces the method of querying the use information of a disk within a specified time, which has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it. DescribeDiskMonitor

2022-06-02 Servers 我要分享

How to use the Linux one-time schedule task at command

This article mainly shows you "how to use the Linux one-time scheduling task at command". The content is easy to understand and clear. I hope it can help you solve your doubts. Let the editor lead you to study and learn how to use the Linux one-time scheduling task at command.

2022-06-02 Development 我要分享

12C ogg cheated and cheated teammates to report wrong OGG-00868 ORA.

Colleagues operate normally, and stop an ogg process, the database is 12c. Ogg is certainly the 12c version. Everything is a normal operation, but there is a deceptive effect, almost four people, engaged in nearly 3 hours. Let's take a look at the detailed error report; GGSCI (dw

2022-06-01 Database 我要分享

How to modify ELF by Linux to solve the problem of glibc compatibility

What this article shares with you is about how Linux modifies ELF to solve glibc compatibility problems. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Linux gl

2022-06-02 Development 我要分享

The usage of sar Command in Linux system

This article introduces the knowledge of "the usage of sar command in Linux system". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something! 1. Life

2022-06-01 Servers 我要分享

How to optimize sql with join in Mysql

How to optimize sql with join in Mysql? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. 0. Prepare related tables for the next test of the user1 table

2022-05-31 Database 我要分享

How mysql uses Join to optimize SQL statements

This article mainly explains "how mysql uses Join to optimize SQL sentences". The explanation in this article is simple, clear and easy to learn and understand. Please follow the editor's train of thought to study and learn "how mysql uses Join to optimize SQL sentences".

2022-05-31 Database 我要分享

What is the master-slave replication method for MySQL Xtrabackup building?

This article mainly explains "what is the master-slave replication method of MySQL Xtrabackup building". The content of the explanation in this article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "MySQL Xtrabacku."

2022-05-31 Database 我要分享

Pandas from entry to upstairs

There are mainly two kinds of data objects SeriesDataFrame for data object pandas. Note: the following code uses pandas version 0.20.1, and SeriesSeries is introduced through import pandas as pd.

2022-06-03 Internet Technology 我要分享

How to analyze the writeup of CTF

This article will explain in detail the writeup of several CTF questions for you. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article. This is a relatively simple PWN question, first drag to IDA Jane

2022-05-31 Network Security 我要分享

How to use tsar to monitor system status in Linux

Editor to share with you how to use tsar in Linux to monitor the status of the system, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it! A brief introduction to tsar

2022-06-01 Servers 我要分享